Acquisition of Entity-Relationship Models from Natural Language Specifications using Heuristics
نویسندگان
چکیده
This paper describes a heuristics-based approach in the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from natural language specifications and describes the implementation of such a system called ERConverter. Though this is a semi-automatic transformation process, ER-Converter aims to require minimal human intervention during the process. ER-Converter has been evaluated in blind trials against a set of database problems. ERConverter has an average of 90% recall and 85% precision. In terms of user intervention, ER-Converter requires very little human assistance with only 1.6% in the test dataset. The evaluation results are discussed and demonstrate that ER-Converter could be used, for example, within the domain model of a multimedia intelligent tutoring system, designed to assist in the learning and teaching of databases.
منابع مشابه
Obtaining E-R Diagrams Semi-Automatically from Natural Language Specifications
Since their inception, entity relationship models have played a central role in systems specification, analysis and development. They have become an important part of several development methodologies and standards such as SSADM. Obtaining entity relationship models, can however, be a lengthy and time consuming task for all but the very smallest of specifications. This paper describes a semi-au...
متن کاملGenerating ER Diagrams from Requirement Specifications Based On Natural Language Processing
An Entity Relationship (ER) data model is a high level conceptual model that describes information as entities, attributes, and relationships. Entity relationship modeling designed to facilitate database design. The abstract nature of Entity Relationship diagrams can be discouraging task to both designers and student alike. This paper deals with the problem of extracting ER elements from natura...
متن کاملAutomation of Database Design through Semantic Analysis
This paper presents the use of heuristics gained from the syntactic and semantic knowledge for the creation of database design in terms of the Entity-Relationship(ER) model through natural language processing. The application of both syntactic and semantic heuristics is used as the strategy to obtain the relevant ER elements such as entities, attributes and relationships from the specifications...
متن کاملLanguage development and acquisition in children
Language acquisition is a natural developmental process and is unique to Homo sapiens in which a child acquiring his or her mother tongue as a first language. The simplest theory of language development is that children learn language by imitating adult language. A second possibility is that children acquire language through conditioning. Noam Chomsky put forward innateness hypothesis. Piaget ...
متن کاملHeuristics-based entity-relationship modelling through natural language processing
Here we propose new heuristics that assist the semi-automated generation of Entity-Relationship (ER) diagrams for database modelling from a natural language description and describe the implementation of such a system called ER-Converter. Though this is a semi-automatic transformation process, ER-Converter aims to require minimal human intervention during the process. ER-Converter has been eval...
متن کامل